Save
Ask
Tour
Hide
Share
$549,333
New Listing

ROCK CLIFF FARMS
40 Old Louisquisset Pike 203
North Smithfield, RI 02896

For Sale|Condominium|Active
2
Beds
3
Total Baths
2
Full Baths
1
Partial Bath
2,700
SqFt
$203
/SqFt
2007
Built
County:
Providence

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

Call Now: ​401-559-7674
Is this the listing for you? We can help make it yours.
​401-559-7674
40 Old Louisquisset Pike 20340 Old Louisquisset Pike 20340 Old Louisquisset Pike 20340 Old Louisquisset Pike 203
Save
Ask
Tour
Hide
Share

Welcome to highly sought-after Rock Cliff Farms! Offering approximately 2,700 sq. ft. of living space, this beautiful oversized condo offers an exceptional amount of space, plenty of storage, and a flexible and functional layout. Step inside to a well-appointed kitchen featuring granite countertops, stainless steel appliances, center island, abundant cabinetry, and a pantry closet, along with a conveniently located half bath. The kitchen flows into the spacious dining and living areas, highlighted by a cozy gas fireplace and slider leading to the outdoor deck. Also located on the first floor is one of two primary suites, complete with a private en-suite bath, double closets, and the added convenience of a washer and dryer. Upstairs, an additional living area offers endless possibilities perfect for a home office, second living room, rec room, playroom, or flex space. Continue into the second spacious primary suite, also featuring its own en-suite bath and double closets. The finished basement provides even more space to enjoy, along with additional storage, while central air and an attached garage add to the comfort and convenience of this impressive condo. Enjoy the beautifully maintained grounds of Rock Cliff Farms and a location that is hard to beat, with easy highway access and close proximity to shopping, restaurants, and everyday amenities. This beautiful condo is ready to welcome its new owner! *Subject to seller finding suitable housing*

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$549,333
Days On Site 
0 Days
Bedrooms 
2
Inside Area (SqFt) 
2,700 sqft
Total Baths 
3
Full Baths 
2
Partial Baths 
1
Lot Size 
N/A
Year Built 
2007
MLS® Number 
1421117
Status 
Active
Property Tax 
$5,592
HOA/Condo/Coop Fees 
$325 monthly
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
11 hours agoListing first seen on site
15 hours agoListing updated with changes from the MLS®
General Features
Attached Garage 
Yes
Foundation 
Combination
Garage 
Yes
Garage Spaces 
1
Levels 
Three Or MoreTwo
Number Of Stories 
2
Parking 
AssignedAttachedGarage
Parking Spaces 
2
Pets 
Yes
Property Sub Type 
Condominium
SqFt Above 
1866
SqFt Below 
834
SqFt Total 
2700
Utilities 
Sewer ConnectedWater Connected
Interior Features
Appliances 
DishwasherGas Water HeaterMicrowaveOvenRangeRefrigeratorWater Heater
Basement 
FullFinishedInterior Entry
Cooling 
Central Air
Electric 
200+ Amp Service
Fireplace 
Yes
Fireplace Features 
Gas
Fireplaces 
1
Flooring 
CarpetHardwood
Heating 
Natural GasForced Air
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Vinyl Siding
Patio And Porch 
DeckPorch
Community Features
Association Dues 
325
HOA Fee Frequency 
Monthly
Listing courtesy of The ALBA Group of Innovations Realty [email protected]



Listing information is provided by Participants of the State-Wide MLS of Rhode Island, Inc. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, State-Wide MLS of Rhode Island, Inc.
Last checked: 2026-08-20 10:48 AM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share